write dataframe to csv python

import pandas as pd

# Dataframe example
df = pd.DataFrame({'col_A':[1,5,7,8],'col_B':[9,7,4,3]})

# Save dataframe as csv file in the current folder
df.to_csv('filename.csv', index = False, encoding='utf-8') # False: not include index
print(df)

#Note: to Save dataframe as csv file in other folder use instead:

''' 
df.to_csv('Path/filename.csv', index = False, encoding='utf-8') # Replace 'Path' by the wanted folder
''';

df.to_csv (r'C:\Users\John\Desktop\export_dataframe.csv', index = None, header=True) 

df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv', index = False)

df.to_csv(file_name, sep='\t')

df.to_csv(file_name, sep='\t', encoding='utf-8')